CREATE TABLE [dbo].[tr_ProjectAlertEmail](
	[ProjectAlertEmailId] [uniqueidentifier] ROWGUIDCOL  NOT NULL,
	[ProjectId] [uniqueidentifier] NOT NULL,
	[Email] [varchar](max) NOT NULL
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

ALTER TABLE [dbo].[tr_ProjectAlertEmail] ADD  CONSTRAINT [DF_tr_ProjectAlertEmail_ProjectAlertEmailId]  DEFAULT (newid()) FOR [ProjectAlertEmailId]
GO

